Tabela ExportList

Definicja tabeli ExportList

Name

ExportList

Code

ExportList

Comment

Logowanie wykonan raportów RLO i PZH (generujacych xml dla NFZ)


Lista kolumn tabeli ExportList

Name

Code

ExportListID

ExportListID

SysFctID

SysFctID

PersonID

PersonID

ExportDT

ExportDT

Description

Description

CritStartDT

CritStartDT

GenNo

GenNo

ReportType

ReportType


Kolumna ExportListID tabeli ExportList

Definicja kolumny ExportListID tabeli ExportList

Name

ExportListID

Code

ExportListID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SysFctID tabeli ExportList

Definicja kolumny SysFctID tabeli ExportList

Name

SysFctID

Code

SysFctID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

rozróznienie na logujacy raport (RLO/PHZ)


Kolumna PersonID tabeli ExportList

Definicja kolumny PersonID tabeli ExportList

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pacjenta


Kolumna ExportDT tabeli ExportList

Definicja kolumny ExportDT tabeli ExportList

Name

ExportDT

Code

ExportDT

Data Type

DATE

Mandatory

Yes

Comment

data wykonania raportu


Kolumna Description tabeli ExportList

Definicja kolumny Description tabeli ExportList

Name

Description

Code

Description

Data Type

VARCHAR2(512)

Mandatory

No

Comment

kompatybilnosc wstecz z tabela ExportsList(opis)


Kolumna CritStartDT tabeli ExportList

Definicja kolumny CritStartDT tabeli ExportList

Name

CritStartDT

Code

CritStartDT

Data Type

DATE

Mandatory

No

Comment

Data, dla której wykonano raport


Kolumna GenNo tabeli ExportList

Definicja kolumny GenNo tabeli ExportList

Name

GenNo

Code

GenNo

Data Type

NUMBER(10)

Mandatory

No

Comment

numer wygenerowania raportu (RLO -> atrybut XML)


Kolumna ReportType tabeli ExportList

Definicja kolumny ReportType tabeli ExportList

Name

ReportType

Code

ReportType

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Typ raportu RLO ( LIOCZ / LIOCZ_SPEC / KOL )


Lista kluczy tabeli ExportList

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ExportList

Definicja klucza Identifier_1 tabeli ExportList

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment